Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	37113
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.4 MiB
Average record size in memory	152.0 B

Variable types

NUM	15
CAT	4

Reproduction

Analysis started	2021-05-20 09:34:33.437759
Analysis finished	2021-05-20 09:35:06.552420
Duration	33.11 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`done_at` has a high cardinality: 37069 distinct values	High cardinality
`travel_start_time` has a high cardinality: 37077 distinct values	High cardinality
`trip_id` is highly correlated with `id`	High correlation
`id` is highly correlated with `trip_id`	High correlation
`g_distance` is highly correlated with `duration`	High correlation
`duration` is highly correlated with `g_distance`	High correlation
`done_at` is uniformly distributed	Uniform
`travel_start_time` is uniformly distributed	Uniform
`id` has unique values	Unique
`trip_start` has unique values	Unique
`duration` has 1616 (4.4%) zeros	Zeros
`g_distance` has 1608 (4.3%) zeros	Zeros

id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct count	37113
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	835275.62748902
Minimum	100274
Maximum	2153861
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	100274
5-th percentile	257747.2
Q1	426952
median	667723
Q3	1327766
95-th percentile	1672961.2
Maximum	2153861
Range	2053587
Interquartile range (IQR)	900814

Descriptive statistics

Standard deviation	495616.6425
Coefficient of variation (CV)	0.5933570024
Kurtosis	-0.8782917444
Mean	835275.6275
Median Absolute Deviation (MAD)	302165
Skewness	0.6401494799
Sum	3.099958436e+10
Variance	2.456358564e+11

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
462846	1	< 0.1%
2118814	1	< 0.1%
337230	1	< 0.1%
539981	1	< 0.1%
1587760	1	< 0.1%
396619	1	< 0.1%
197962	1	< 0.1%
486727	1	< 0.1%
419142	1	< 0.1%
281923	1	< 0.1%
Other values (37103)	37103	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100274	1	< 0.1%
100327	1	< 0.1%
100440	1	< 0.1%
100548	1	< 0.1%
100562	1	< 0.1%

Value	Count	Frequency (%)
2153861	1	< 0.1%
2153819	1	< 0.1%
2153429	1	< 0.1%
2153227	1	< 0.1%
2152774	1	< 0.1%

start_lat
Real number (ℝ_≥0)

Distinct count	15
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52.02249676871987
Minimum	51.3614965
Maximum	52.6002058
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	51.3614965
5-th percentile	52.0201841
Q1	52.0201841
median	52.0201841
Q3	52.02039
95-th percentile	52.02039
Maximum	52.6002058
Range	1.2387093
Interquartile range (IQR)	0.0002059

Descriptive statistics

Standard deviation	0.03571243005
Coefficient of variation (CV)	0.0006864805088
Kurtosis	218.7775273
Mean	52.02249677
Median Absolute Deviation (MAD)	0
Skewness	13.11702163
Sum	1930710.923
Variance	0.00127537766

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52.0201841	22584	60.9%
52.02039	14336	38.6%
52.538085	115	0.3%
52.0204466	21	0.1%
52.6000377	19	0.1%
52.5167747	12	< 0.1%
52.538086	9	< 0.1%
51.3614965	5	< 0.1%
52.5377571	3	< 0.1%
52.0201209	2	< 0.1%
Other values (5)	7	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
51.3614965	5	< 0.1%
52.0201209	2	< 0.1%
52.0201841	22584	60.9%
52.0202035	1	< 0.1%
52.02039	14336	38.6%

Value	Count	Frequency (%)
52.6002058	1	< 0.1%
52.6002057	2	< 0.1%
52.6000377	19	0.1%
52.5991939	2	< 0.1%
52.5396787	1	< 0.1%

start_lon
Real number (ℝ_≥0)

Distinct count	16
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.158654064265891
Minimum	4.7450827
Maximum	6.1740619
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	4.7450827
5-th percentile	5.15492
Q1	5.15492
median	5.1550517
Q3	5.1550517
95-th percentile	5.1550517
Maximum	6.1740619
Range	1.4289792
Interquartile range (IQR)	0.0001317

Descriptive statistics

Standard deviation	0.06345695791
Coefficient of variation (CV)	0.01230106867
Kurtosis	239.1209558
Mean	5.158654064
Median Absolute Deviation (MAD)	0
Skewness	15.09923149
Sum	191453.1283
Variance	0.004026785507

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5.1550517	22580	60.8%
5.15492	14336	38.6%
6.165409	115	0.3%
5.1557132	21	0.1%
4.7450827	19	0.1%
6.0830219	12	< 0.1%
6.1654075	9	< 0.1%
6.1419777	5	< 0.1%
5.1550516	4	< 0.1%
6.1663369	3	< 0.1%
Other values (6)	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4.7450827	19	0.1%
4.745461	2	< 0.1%
4.7458026	2	< 0.1%
4.7458027	1	< 0.1%
5.1538734	2	< 0.1%

Value	Count	Frequency (%)
6.1740619	1	< 0.1%
6.1663369	3	< 0.1%
6.165409	115	0.3%
6.1654075	9	< 0.1%
6.1419777	5	< 0.1%

stop_lat
Real number (ℝ_≥0)

Distinct count	14336
Unique (%)	38.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52.133312704987475
Minimum	50.76751
Maximum	53.41821
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	50.76751
5-th percentile	51.41412
Q1	51.93012
median	52.1237004
Q3	52.3626641
95-th percentile	52.855926
Maximum	53.41821
Range	2.6507
Interquartile range (IQR)	0.4325441

Descriptive statistics

Standard deviation	0.4232640378
Coefficient of variation (CV)	0.008118878619
Kurtosis	1.281902811
Mean	52.1333127
Median Absolute Deviation (MAD)	0.2265396
Skewness	-0.1950817722
Sum	1934823.634
Variance	0.1791524457

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52.1708268	228	0.6%
52.2094313	194	0.5%
52.3149589	188	0.5%
52.0452939	184	0.5%
52.2947301	181	0.5%
51.9390716	180	0.5%
52.3325251	177	0.5%
52.2939983	174	0.5%
52.3342671	161	0.4%
52.3653783	154	0.4%
Other values (14326)	35292	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50.76751	1	< 0.1%
50.76879	1	< 0.1%
50.76883	1	< 0.1%
50.76934	1	< 0.1%
50.76936	3	< 0.1%

Value	Count	Frequency (%)
53.41821	2	< 0.1%
53.4179	1	< 0.1%
53.41751	1	< 0.1%
53.41687	1	< 0.1%
53.41668	1	< 0.1%

stop_lon
Real number (ℝ_≥0)

Distinct count	14598
Unique (%)	39.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.139928943979198
Minimum	3.3778
Maximum	7.20996
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	3.3778
5-th percentile	4.3005051
Q1	4.66312
median	5.0171841
Q3	5.52257
95-th percentile	6.493056
Maximum	7.20996
Range	3.83216
Interquartile range (IQR)	0.85945

Descriptive statistics

Standard deviation	0.6522013548
Coefficient of variation (CV)	0.1268891772
Kurtosis	0.1827111995
Mean	5.139928944
Median Absolute Deviation (MAD)	0.3921859
Skewness	0.7634924307
Sum	190758.1829
Variance	0.4253666072

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5.3695659	225	0.6%
5.0209296	194	0.5%
4.9777084	188	0.5%
4.5376113	184	0.5%
4.5631292	181	0.5%
4.9557311	181	0.5%
4.8606028	177	0.5%
4.8732648	174	0.5%
4.8669631	161	0.4%
4.8848512	153	0.4%
Other values (14588)	35295	95.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.3778	4	< 0.1%
3.38715	3	< 0.1%
3.44192	1	< 0.1%
3.4458	2	< 0.1%
3.45039	1	< 0.1%

Value	Count	Frequency (%)
7.20996	1	< 0.1%
7.20854	1	< 0.1%
7.20004	1	< 0.1%
7.1937	1	< 0.1%
7.1809	1	< 0.1%

quantity
Real number (ℝ_≥0)

Distinct count	76
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.806132621992294
Minimum	0
Maximum	130
Zeros	7
Zeros (%)	< 0.1%
Memory size	289.9 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	18
Maximum	130
Range	130
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	6.888915739
Coefficient of variation (CV)	1.809951576
Kurtosis	25.21769697
Mean	3.806132622
Median Absolute Deviation (MAD)	0
Skewness	4.076295951
Sum	141257
Variance	47.45716006

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	23759	64.0%
2	4164	11.2%
3	1484	4.0%
4	921	2.5%
5	731	2.0%
6	539	1.5%
7	451	1.2%
9	413	1.1%
8	407	1.1%
10	356	1.0%
Other values (66)	3888	10.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7	< 0.1%
1	23759	64.0%
2	4164	11.2%
3	1484	4.0%
4	921	2.5%

Value	Count	Frequency (%)
130	2	< 0.1%
102	1	< 0.1%
100	1	< 0.1%
89	1	< 0.1%
86	1	< 0.1%

done_at
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	37069
Unique (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	289.9 KiB

2019-05-22 20:43:48+00:00	6
2020-06-04 02:56:54+00:00	5
2020-01-25 02:29:33+00:00	2
2020-04-03 09:12:09+00:00	2
2019-08-14 00:34:55+00:00	2
Other values (37064)	37096

Common Values
Length

Value	Count	Frequency (%)
2019-05-22 20:43:48+00:00	6	< 0.1%
2020-06-04 02:56:54+00:00	5	< 0.1%
2020-01-25 02:29:33+00:00	2	< 0.1%
2020-04-03 09:12:09+00:00	2	< 0.1%
2019-08-14 00:34:55+00:00	2	< 0.1%
2020-04-10 13:10:23+00:00	2	< 0.1%
2019-11-14 09:31:00+00:00	2	< 0.1%
2019-04-25 17:25:19+00:00	2	< 0.1%
2019-09-19 18:07:29+00:00	2	< 0.1%
2019-09-04 04:41:29+00:00	2	< 0.1%
Other values (37059)	37086	99.9%

Length

Max length	32
Median length	25
Mean length	25.81612912
Min length	25

trip_start
Categorical

UNIQUE

Distinct count	37113
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	289.9 KiB

2019-09-23 23:24:20.176111+00:00	1
2021-02-22 23:34:53.361000+00:00	1
2020-12-10 23:08:26.927000+00:00	1
2019-11-22 11:14:28.864315+00:00	1
2021-02-27 00:53:06.747000+00:00	1
Other values (37108)	37108

Common Values
Length

Value	Count	Frequency (%)
2019-09-23 23:24:20.176111+00:00	1	< 0.1%
2021-02-22 23:34:53.361000+00:00	1	< 0.1%
2020-12-10 23:08:26.927000+00:00	1	< 0.1%
2019-11-22 11:14:28.864315+00:00	1	< 0.1%
2021-02-27 00:53:06.747000+00:00	1	< 0.1%
2020-02-28 03:26:24.093677+00:00	1	< 0.1%
2020-01-15 06:26:33.668097+00:00	1	< 0.1%
2020-07-29 05:16:49.823475+00:00	1	< 0.1%
2020-05-04 23:15:04.023822+00:00	1	< 0.1%
2019-11-20 03:03:34.829755+00:00	1	< 0.1%
Other values (37103)	37103	> 99.9%

Length

Max length	32
Median length	32
Mean length	31.99886832
Min length	25

trip_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	5272
Unique (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	74161.2301888826
Minimum	24309
Maximum	145760
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	24309
5-th percentile	35552.2
Q1	49327
median	68873
Q3	100242
95-th percentile	120019
Maximum	145760
Range	121451
Interquartile range (IQR)	50915

Descriptive statistics

Standard deviation	28610.67344
Coefficient of variation (CV)	0.3857901679
Kurtosis	-0.9655626489
Mean	74161.23019
Median Absolute Deviation (MAD)	22420
Skewness	0.3897918243
Sum	2752345736
Variance	818570634.8

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
83030	38	0.1%
78210	26	0.1%
114876	25	0.1%
111601	24	0.1%
79707	23	0.1%
98433	23	0.1%
44256	23	0.1%
78233	23	0.1%
44790	22	0.1%
56720	22	0.1%
Other values (5262)	36864	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24309	11	< 0.1%
24507	3	< 0.1%
24571	4	< 0.1%
24610	1	< 0.1%
24620	2	< 0.1%

Value	Count	Frequency (%)
145760	1	< 0.1%
145758	3	< 0.1%
145750	1	< 0.1%
145749	1	< 0.1%
145748	1	< 0.1%

customer_id
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	289.9 KiB

866	24086
1	13027

Common Values
Length

Value	Count	Frequency (%)
866	24086	64.9%
1	13027	35.1%

Length

Max length	3
Median length	3
Mean length	2.297981839
Min length	1

driver_id
Real number (ℝ_≥0)

Distinct count	279
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	886.2831352895212
Minimum	26.0
Maximum	16731.0
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	26
5-th percentile	117
Q1	427
median	598
Q3	794
95-th percentile	1136
Maximum	16731
Range	16705
Interquartile range (IQR)	367

Descriptive statistics

Standard deviation	1676.932599
Coefficient of variation (CV)	1.892095802
Kurtosis	32.70876532
Mean	886.2831353
Median Absolute Deviation (MAD)	183
Skewness	5.62633015
Sum	32892626
Variance	2812102.943

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
744	1193	3.2%
431	1153	3.1%
117	1135	3.1%
715	912	2.5%
621	866	2.3%
242	810	2.2%
450	751	2.0%
742	747	2.0%
415	739	2.0%
555	714	1.9%
Other values (269)	28093	75.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
26	19	0.1%
32	213	0.6%
44	1	< 0.1%
49	1	< 0.1%
70	363	1.0%

Value	Count	Frequency (%)
16731	9	< 0.1%
16557	21	0.1%
16402	5	< 0.1%
15347	41	0.1%
14753	1	< 0.1%

kilometers
Real number (ℝ_≥0)

Distinct count	713
Unique (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2091.339368954275
Minimum	0.0
Maximum	725974.0
Zeros	95
Zeros (%)	0.3%
Memory size	289.9 KiB

Quantile statistics

Minimum	0
5-th percentile	137
Q1	205
median	262
Q3	378
95-th percentile	579.4
Maximum	725974
Range	725974
Interquartile range (IQR)	173

Descriptive statistics

Standard deviation	25196.20523
Coefficient of variation (CV)	12.04787975
Kurtosis	379.2525359
Mean	2091.339369
Median Absolute Deviation (MAD)	71
Skewness	17.87822476
Sum	77615878
Variance	634848758.2

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
196	327	0.9%
229	242	0.7%
211	238	0.6%
247	238	0.6%
257	231	0.6%
203	228	0.6%
235	225	0.6%
218	225	0.6%
249	223	0.6%
252	221	0.6%
Other values (703)	34715	93.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	95	0.3%
7	1	< 0.1%
16	1	< 0.1%
18	1	< 0.1%
19	17	< 0.1%

Value	Count	Frequency (%)
725974	3	< 0.1%
685436	11	< 0.1%
573036	12	< 0.1%
557828	1	< 0.1%
531762	2	< 0.1%

stop_start_lat
Real number (ℝ_≥0)

Distinct count	13222
Unique (%)	35.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	52.121142956266006
Minimum	50.76751
Maximum	53.4366429
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	50.76751
5-th percentile	51.45431
Q1	51.97508
median	52.07474
Q3	52.34659
95-th percentile	52.791646
Maximum	53.4366429
Range	2.6691329
Interquartile range (IQR)	0.37151

Descriptive statistics

Standard deviation	0.3996417328
Coefficient of variation (CV)	0.007667555048
Kurtosis	1.910975717
Mean	52.12114296
Median Absolute Deviation (MAD)	0.1884001
Skewness	-0.1003403981
Sum	1934371.979
Variance	0.1597135146

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
52.0201841	3418	9.2%
52.02039	1799	4.8%
52.1708268	201	0.5%
52.3149589	182	0.5%
52.3325251	167	0.4%
51.9390716	167	0.4%
52.3653783	151	0.4%
52.3626641	150	0.4%
52.4017389	149	0.4%
52.35204	148	0.4%
Other values (13212)	30581	82.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
50.76751	1	< 0.1%
50.76879	1	< 0.1%
50.76883	1	< 0.1%
50.76934	1	< 0.1%
50.76936	3	< 0.1%

Value	Count	Frequency (%)
53.4366429	1	< 0.1%
53.41821	2	< 0.1%
53.4179	1	< 0.1%
53.41751	1	< 0.1%
53.41687	1	< 0.1%

stop_start_lon
Real number (ℝ_≥0)

Distinct count	13437
Unique (%)	36.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.142898002516638
Minimum	3.3778
Maximum	7.20996
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	3.3778
5-th percentile	4.3063796
Q1	4.71321
median	5.1369355
Q3	5.4092616
95-th percentile	6.4305
Maximum	7.20996
Range	3.83216
Interquartile range (IQR)	0.6960516

Descriptive statistics

Standard deviation	0.6117179154
Coefficient of variation (CV)	0.1189442052
Kurtosis	0.6310828731
Mean	5.142898003
Median Absolute Deviation (MAD)	0.3607055
Skewness	0.8160519563
Sum	190868.3736
Variance	0.374198808

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
5.1550517	3414	9.2%
5.15492	1799	4.8%
5.3695659	199	0.5%
4.9777084	182	0.5%
4.5631292	168	0.5%
4.8606028	167	0.4%
4.9274987	150	0.4%
4.8848512	150	0.4%
4.9438456	149	0.4%
4.8649699	148	0.4%
Other values (13427)	30587	82.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.3778	4	< 0.1%
3.38715	3	< 0.1%
3.44192	1	< 0.1%
3.4458	2	< 0.1%
3.45039	1	< 0.1%

Value	Count	Frequency (%)
7.20996	1	< 0.1%
7.20854	1	< 0.1%
7.20004	1	< 0.1%
7.1937	1	< 0.1%
7.1809	1	< 0.1%

travel_start_time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct count	37077
Unique (%)	99.9%
Missing	0
Missing (%)	0.0%
Memory size	289.9 KiB

2019-05-22 20:43:48+00:00	6
2020-06-04 02:56:54+00:00	4
2019-10-02 09:57:38+00:00	2
2019-09-19 18:07:29+00:00	2
2019-06-19 14:02:56+00:00	2
Other values (37072)	37097

Common Values
Length

Value	Count	Frequency (%)
2019-05-22 20:43:48+00:00	6	< 0.1%
2020-06-04 02:56:54+00:00	4	< 0.1%
2019-10-02 09:57:38+00:00	2	< 0.1%
2019-09-19 18:07:29+00:00	2	< 0.1%
2019-06-19 14:02:56+00:00	2	< 0.1%
2020-04-10 13:10:23+00:00	2	< 0.1%
2020-07-31 17:41:19+00:00	2	< 0.1%
2020-04-11 13:21:42+00:00	2	< 0.1%
2019-08-14 00:34:55+00:00	2	< 0.1%
2020-10-14 13:16:31+00:00	2	< 0.1%
Other values (37067)	37087	99.9%

Length

Max length	32
Median length	25
Mean length	26.6547032
Min length	25

duration
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	4263
Unique (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	21.706149237913042
Minimum	0.0
Maximum	259.71666666666664
Zeros	1616
Zeros (%)	4.4%
Memory size	289.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.6433333333
Q1	9.1
median	16
Q3	28
95-th percentile	60.26666667
Maximum	259.7166667
Range	259.7166667
Interquartile range (IQR)	18.9

Descriptive statistics

Standard deviation	20.09958721
Coefficient of variation (CV)	0.9259858572
Kurtosis	9.385494456
Mean	21.70614924
Median Absolute Deviation (MAD)	8.6
Skewness	2.412925331
Sum	805580.3167
Variance	403.9934059

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1616	4.4%
2.816666667	179	0.5%
12.26666667	157	0.4%
13.7	146	0.4%
3.383333333	145	0.4%
8.9	127	0.3%
37.56666667	110	0.3%
14.28333333	110	0.3%
14.11666667	109	0.3%
18.91666667	101	0.3%
Other values (4253)	34313	92.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1616	4.4%
0.01666666667	53	0.1%
0.03333333333	4	< 0.1%
0.05	7	< 0.1%
0.06666666667	2	< 0.1%

Value	Count	Frequency (%)
259.7166667	1	< 0.1%
249.1333333	1	< 0.1%
174.1833333	1	< 0.1%
169.4666667	1	< 0.1%
167.6166667	1	< 0.1%

g_distance
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	18751
Unique (%)	50.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	22.743591032791745
Minimum	0.0
Maximum	255.752
Zeros	1608
Zeros (%)	4.3%
Memory size	289.9 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1
Q1	4.087
median	11.751
Q3	28.744
95-th percentile	81.0824
Maximum	255.752
Range	255.752
Interquartile range (IQR)	24.657

Descriptive statistics

Standard deviation	30.18080574
Coefficient of variation (CV)	1.327002658
Kurtosis	11.42007324
Mean	22.74359103
Median Absolute Deviation (MAD)	9.226
Skewness	2.863091201
Sum	844082.894
Variance	910.8810353

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1608	4.3%
0.988	137	0.4%
9.439	132	0.4%
8.852	125	0.3%
0.96	123	0.3%
3.991	111	0.3%
52.593	105	0.3%
9.687	95	0.3%
24.176	94	0.3%
8.58	93	0.3%
Other values (18741)	34490	92.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1608	4.3%
0.001	3	< 0.1%
0.002	2	< 0.1%
0.003	6	< 0.1%
0.004	48	0.1%

Value	Count	Frequency (%)
255.752	1	< 0.1%
255.166	1	< 0.1%
254.232	1	< 0.1%
253.745	1	< 0.1%
251.376	1	< 0.1%

turns
Real number (ℝ_≥0)

Distinct count	40
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	12.921914154070002
Minimum	1
Maximum	43
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	9
median	13
Q3	17
95-th percentile	22
Maximum	43
Range	42
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	5.627195524
Coefficient of variation (CV)	0.4354769314
Kurtosis	0.1065620855
Mean	12.92191415
Median Absolute Deviation (MAD)	4
Skewness	-0.007696517568
Sum	479571
Variance	31.66532947

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	3081	8.3%
14	2835	7.6%
13	2669	7.2%
16	2555	6.9%
15	2467	6.6%
17	2318	6.2%
11	2275	6.1%
10	2165	5.8%
9	1833	4.9%
1	1748	4.7%
Other values (30)	13167	35.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1748	4.7%
2	218	0.6%
3	338	0.9%
4	578	1.6%
5	816	2.2%

Value	Count	Frequency (%)
43	1	< 0.1%
42	1	< 0.1%
40	1	< 0.1%
38	2	< 0.1%
36	3	< 0.1%

total_distance
Real number (ℝ_≥0)

Distinct count	3923
Unique (%)	10.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	202.93789413413094
Minimum	3.54
Maximum	718.327
Zeros	0
Zeros (%)	0.0%
Memory size	289.9 KiB

Quantile statistics

Minimum	3.54
5-th percentile	72.357
Q1	130.13
median	181.698
Q3	259.846
95-th percentile	394.22
Maximum	718.327
Range	714.787
Interquartile range (IQR)	129.716

Descriptive statistics

Standard deviation	105.6803466
Coefficient of variation (CV)	0.5207521594
Kurtosis	2.710364341
Mean	202.9378941
Median Absolute Deviation (MAD)	59.744
Skewness	1.273749001
Sum	7531634.065
Variance	11168.33566

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
91.579	132	0.4%
72.357	130	0.4%
123.392	129	0.3%
276.2	111	0.3%
77.341	96	0.3%
142.404	90	0.2%
60.076	87	0.2%
104.955	83	0.2%
205.5	80	0.2%
160.846	77	0.2%
Other values (3913)	36098	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.54	1	< 0.1%
8.329	1	< 0.1%
9.143	1	< 0.1%
9.363	19	0.1%
9.372	1	< 0.1%

Value	Count	Frequency (%)
718.327	7	< 0.1%
716.281	15	< 0.1%
700.096	4	< 0.1%
697.758	13	< 0.1%
686.566	15	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	id	start_lat	start_lon	stop_lat	stop_lon	quantity	done_at	trip_start	trip_id	customer_id	driver_id	kilometers	stop_start_lat	stop_start_lon	travel_start_time	duration	g_distance	turns	total_distance
0	100274	52.02039	5.15492	51.983227	5.079331	19	2019-01-22 01:43:49+00:00	2019-01-22 00:48:00.239601+00:00	24309	1	533.0	418.0	52.020390	5.154920	2019-01-22 01:01:09.033766+00:00	14.983333	11.582	16	193.992
1	100582	52.02039	5.15492	51.838640	4.957680	11	2019-01-22 02:11:04+00:00	2019-01-22 01:01:09.033766+00:00	24309	1	533.0	418.0	51.983227	5.079331	2019-01-22 01:43:49+00:00	18.916667	21.378	12	193.992
2	100327	52.02039	5.15492	51.979898	4.583965	2	2019-01-22 03:01:26+00:00	2019-01-22 00:47:59.436893+00:00	24309	1	533.0	418.0	51.838640	4.957680	2019-01-22 02:11:04+00:00	38.033333	45.406	17	193.992
3	100611	52.02039	5.15492	51.960995	4.543000	25	2019-01-22 03:22:42+00:00	2019-01-22 00:47:58.148863+00:00	24309	1	533.0	418.0	51.979898	4.583965	2019-01-22 03:01:26+00:00	11.500000	5.352	11	193.992
4	100629	52.02039	5.15492	51.965778	4.221331	2	2019-01-22 03:52:17+00:00	2019-01-22 00:50:42.050646+00:00	24309	1	533.0	418.0	51.960995	4.543000	2019-01-22 03:22:42+00:00	27.283333	29.540	14	193.992
5	100548	52.02039	5.15492	51.920352	4.451595	8	2019-01-22 04:07:54+00:00	2019-01-22 00:47:56.887189+00:00	24309	1	533.0	418.0	51.965778	4.221331	2019-01-22 03:52:17+00:00	19.750000	21.597	17	193.992
6	100790	52.02039	5.15492	51.909947	4.448196	2	2019-01-22 04:21:33+00:00	2019-01-22 00:47:55.106156+00:00	24309	1	533.0	418.0	51.920352	4.451595	2019-01-22 04:07:54+00:00	5.150000	1.805	10	193.992
7	100593	52.02039	5.15492	51.891700	4.566160	19	2019-01-22 04:43:54+00:00	2019-01-22 00:47:56.389478+00:00	24309	1	533.0	418.0	51.909947	4.448196	2019-01-22 04:21:33+00:00	26.633333	24.353	14	193.992
8	100678	52.02039	5.15492	51.833539	4.644188	1	2019-01-22 05:05:40+00:00	2019-01-22 00:50:42.150849+00:00	24309	1	533.0	418.0	51.891700	4.566160	2019-01-22 04:43:54+00:00	16.250000	12.347	20	193.992
9	100562	52.02039	5.15492	51.837897	4.635991	16	2019-01-22 05:19:44+00:00	2019-01-22 00:47:53.399479+00:00	24309	1	533.0	418.0	51.833539	4.644188	2019-01-22 05:05:40+00:00	3.900000	1.954	10	193.992

Last rows

	id	start_lat	start_lon	stop_lat	stop_lon	quantity	done_at	trip_start	trip_id	customer_id	driver_id	kilometers	stop_start_lat	stop_start_lon	travel_start_time	duration	g_distance	turns	total_distance
37103	2143501	52.020184	5.155052	52.385803	4.841029	5	2021-04-13 10:04:18.296000+00:00	2021-04-13 04:40:29.650000+00:00	145589	1	70.0	212.0	52.332525	4.860603	2021-04-13 07:25:33.373000+00:00	11.016667	8.577	12	58.245
37104	2143651	52.020184	5.155052	53.219780	6.579380	1	2021-04-13 11:58:55+00:00	2021-04-13 05:33:11.305000+00:00	145579	1	14753.0	705.0	52.020184	5.155052	2021-04-13 05:33:11.305000+00:00	122.733333	194.522	19	194.522
37105	2152774	52.020184	5.155052	52.057165	4.493283	1	2021-04-14 00:43:01.482000+00:00	2021-04-13 23:13:24.520000+00:00	145758	1	15347.0	152.0	52.020184	5.155052	2021-04-13 23:14:52.011000+00:00	42.816667	56.781	21	80.855
37106	2153227	52.020184	5.155052	52.018604	4.434019	20	2021-04-14 00:50:28.012000+00:00	2021-04-13 23:13:47.202000+00:00	145758	1	15347.0	152.0	52.057165	4.493283	2021-04-14 00:43:01.482000+00:00	19.200000	12.679	22	80.855
37107	2152660	52.020184	5.155052	51.838640	4.957680	11	2021-04-14 01:07:19.989000+00:00	2021-04-13 23:39:10.383000+00:00	145760	1	15347.0	64.0	52.020184	5.155052	2021-04-13 23:39:10.383000+00:00	25.733333	32.006	12	32.006
37108	2151647	52.020184	5.155052	52.000456	4.331418	22	2021-04-14 01:46:04.376000+00:00	2021-04-13 23:14:52.011000+00:00	145758	1	15347.0	152.0	52.018604	4.434019	2021-04-14 00:50:28.012000+00:00	17.683333	11.395	18	80.855
37109	2143671	52.020184	5.155052	51.581950	4.797580	1	2021-04-14 07:41:02.802000+00:00	2021-04-14 02:54:04.074000+00:00	145745	1	415.0	284.0	52.020184	5.155052	2021-04-14 02:54:04.074000+00:00	45.816667	63.410	14	63.410
37110	2153819	52.020184	5.155052	52.385803	4.841029	1	2021-04-14 07:43:09+00:00	2021-04-14 04:15:53.097000+00:00	145748	1	433.0	264.0	52.020184	5.155052	2021-04-14 04:15:53.097000+00:00	39.900000	55.121	16	55.121
37111	2153861	52.020184	5.155052	52.344430	5.613690	1	2021-04-14 07:50:12.703000+00:00	2021-04-14 05:05:27.413000+00:00	145749	1	713.0	304.0	52.020184	5.155052	2021-04-14 05:05:27.413000+00:00	42.083333	58.208	14	58.208
37112	2153429	52.020184	5.155052	52.045294	4.537611	9	2021-04-14 08:04:51.516000+00:00	2021-04-14 03:14:25.809000+00:00	145750	1	215.0	143.0	52.020184	5.155052	2021-04-14 03:14:25.809000+00:00	37.566667	52.593	13	52.593

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows